UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YW5zsaT3V3QbuySy0Lq18YM5CxEk0JGUYt6f4NxNfzY='
WHERE
key_id = '0a876ca6e7e33b3fa7195d6d96bab5317baef6c6cbc34788d8c2b18d74acea48'
AND (
token = 'YW5zsaT3V3QbuySy0Lq18YM5CxEk0JGUYt6f4NxNfzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)