UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1N35Bo9Axk3A2A7Zrh4M6StS1cF7jYA7jNdUXz7eacY='
WHERE
key_id = 'be562be565ccdd0dce6df0a730843ad409d1f78ddfa221731d276211d0d2a4b9'
AND (
token = '1N35Bo9Axk3A2A7Zrh4M6StS1cF7jYA7jNdUXz7eacY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)