UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NmoLG71MB+JQgkAU1ALMsykk0Et1eGaeObZOeL78PRE='
WHERE
key_id = '496fb1ca67171648e2b270d0f146e680c719e1dc5121e44ae29394dd24427359'
AND (
token = 'NmoLG71MB+JQgkAU1ALMsykk0Et1eGaeObZOeL78PRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)