UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4A4oRZzMFsUakFcAXbzjKfRVB8OTBT9Q6xCnxyhi7p0='
WHERE
key_id = '1d51ab7f13640085aebe2a822bc40c88b809a252b0e3b11fd15ed5b2d5bcd4ce'
AND (
token = '4A4oRZzMFsUakFcAXbzjKfRVB8OTBT9Q6xCnxyhi7p0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)