UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWeUIrFe+UzXiL3Q7O6BfgBuT4/rKRnnTBCt7YXj5Uw='
WHERE
key_id = '5d3def701812ce60737cd33689fe03ae10c2f5522bfd284557b48cf661a6a9ed'
AND (
token = 'nWeUIrFe+UzXiL3Q7O6BfgBuT4/rKRnnTBCt7YXj5Uw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)