UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3KjOTXqa0h0lZiqxBsem+7ojMkeBw8ChfI/HPvRBQWM='
WHERE
key_id = '4a01487e9048d2689e8eb08eba3fef63da6dc16a8c60c584e7aedf08a07c964c'
AND (
token = '3KjOTXqa0h0lZiqxBsem+7ojMkeBw8ChfI/HPvRBQWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)