UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49wbAx4+KEm3ZbTFn9OhxirgzIghj26e7UB+Us2KqS8='
WHERE
key_id = 'd30de686ec3c4b504917388bf6e4f1cee31106e23f8865bc8d95b0e3f809aff3'
AND (
token = '49wbAx4+KEm3ZbTFn9OhxirgzIghj26e7UB+Us2KqS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)