UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2kYTdZm0vgWqUbtC4mLPI1mOjPq4yb8FhjTfbyWv4cE='
WHERE
key_id = 'cee4c91fd6f53c350242a64f7e0a4b4d228b5194af6d2ac96ef531ba3556ae20'
AND (
token = '2kYTdZm0vgWqUbtC4mLPI1mOjPq4yb8FhjTfbyWv4cE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)