UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SjuY1YpdZYmZ1CVRK5gWM9ZkZCBsGoRtLT6waw2hZIE='
WHERE
key_id = 'a5b5a5107fa10782bf02f756c1c87f0a326a33e12d32a7357e9041b7cf163ad5'
AND (
token = 'SjuY1YpdZYmZ1CVRK5gWM9ZkZCBsGoRtLT6waw2hZIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)