UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VZq8OSkX7+aMczt7y2QrX/KMj6c1eNnDMONvHkif6fc='
WHERE
key_id = '7807a648950338f8f725a820f57865e7144e6508fd7110e50b232362c1841d63'
AND (
token = 'VZq8OSkX7+aMczt7y2QrX/KMj6c1eNnDMONvHkif6fc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)