UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MsBn9KXrP59NfWiJ9XO2GjFk3QevMg++hFVY0Eogcd4='
WHERE
key_id = '86533ee0f6553c7f8d21b761d9c4d7d9f938c878332991f119c6fea9fbf43ce0'
AND (
token = 'MsBn9KXrP59NfWiJ9XO2GjFk3QevMg++hFVY0Eogcd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)