UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f0YtGXKXseTy1CwmGu/vD7v0xrqdy4zfpxe0DrLNJOI='
WHERE
key_id = 'e4db66b8cf28b08b06866c91a9aa75fd75ece1a1c1104f67cc7c4ecc0f01b4aa'
AND (
token = 'f0YtGXKXseTy1CwmGu/vD7v0xrqdy4zfpxe0DrLNJOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)