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