UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zC1pLdGpIPGBmF3IEWum+ozjCWEan/t4D4k5yc4GfHk='
WHERE
key_id = 'd957e855ee75469453635c2543d270499f4cf25c81ee504c1d22867a025a6a67'
AND (
token = 'zC1pLdGpIPGBmF3IEWum+ozjCWEan/t4D4k5yc4GfHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)