UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Szip11NHubplrH651+LW0loFtVIizVV3zoa9Q0xqbts='
WHERE
key_id = '56fbba81d12aec4d8c718a01c1f55daa7f9ab7983068d2d1a32c43603f10a96a'
AND (
token = 'Szip11NHubplrH651+LW0loFtVIizVV3zoa9Q0xqbts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)