UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Zrqioh3uXciHZGaIJGOdV9nn51ReqW04LM8CyNqywU='
WHERE
key_id = '678e13fdbc2ed0b393dc1876a6be5c96f0827a8ad43620d770707d7b0d72bc71'
AND (
token = '3Zrqioh3uXciHZGaIJGOdV9nn51ReqW04LM8CyNqywU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)