UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NES47lynYe1ggwbxRnaQKMiT6a6SzjKl532Li9/ltao='
WHERE
key_id = 'f92431d53c732b4436509eeaa8fde43dba3459c8c95c031a85bf6360ebc2ca6d'
AND (
token = 'NES47lynYe1ggwbxRnaQKMiT6a6SzjKl532Li9/ltao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)