UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jNWphBSQWo8J7ckfCb9e4+QLp/1zQOMgPRDU14/XcDI='
WHERE
key_id = '9f3f463f2c3ba66a988d100433d99b121457e638ee7f035ab1c7104e5fd55ae4'
AND (
token = 'jNWphBSQWo8J7ckfCb9e4+QLp/1zQOMgPRDU14/XcDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)