UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5xdKENmbIchuDJHtmyiK67J54keuouqYSVm320RpeiE='
WHERE
key_id = 'aac0fb9773d24329ed8d5cd96fec1caf573eb67ca67da41e3ebf1a33ab8f0f96'
AND (
token = '5xdKENmbIchuDJHtmyiK67J54keuouqYSVm320RpeiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)