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