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