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