UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BW8YdapD9yxu8rZDW9j2lFsKAKNYMd60g8XhgreGVSY='
WHERE
key_id = '9fe375955f7044a0d9d8394ba7548790f9d8f61b437affbc5039e51b25f1bf2b'
AND (
token = 'BW8YdapD9yxu8rZDW9j2lFsKAKNYMd60g8XhgreGVSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)