UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0a1WmTTcI0dFSrMQgWJe4arIxjX+X4NTJJVvxqgQj+A='
WHERE
key_id = '8d04d6c5dc77e3bb6c097311ac7006bf506a8983b0920ee6b63d6c2539a417af'
AND (
token = '0a1WmTTcI0dFSrMQgWJe4arIxjX+X4NTJJVvxqgQj+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)