UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3fL+p+6h3+zQ8pzu9+6yGtZ/YRM7zZrcCgJsVi5vms8='
WHERE
key_id = 'fadc9769bd1eb84b80dd1087db16ca441f9f500db20d61a8dd9450a6645131ca'
AND (
token = '3fL+p+6h3+zQ8pzu9+6yGtZ/YRM7zZrcCgJsVi5vms8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)