UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TVayCG7Miu6BOshGLlMQp1W6i1q1R//6xwa/HtP33qY='
WHERE
key_id = 'c0e3eed84407d7f2c7997e93a82fa94bc80320f9719a63e091603938a362e992'
AND (
token = 'TVayCG7Miu6BOshGLlMQp1W6i1q1R//6xwa/HtP33qY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)