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