UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TNkyuoNkPmRWjkJAYgD9fgNYCVRfvZYRS9G8opoq9TE='
WHERE
key_id = 'e11093a605bd40d66defe80bf4bfa0b0816f2363296e909f67e9bd9c161eb7b2'
AND (
token = 'TNkyuoNkPmRWjkJAYgD9fgNYCVRfvZYRS9G8opoq9TE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)