UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dY78PTdjLYTI3eu1Slpnc0z4rUoOD2aB/obbaxGkWVU='
WHERE
key_id = '2320706dec1d25660d20e488d65da57114d8bbac114fd25efdfe42b8890493a7'
AND (
token = 'dY78PTdjLYTI3eu1Slpnc0z4rUoOD2aB/obbaxGkWVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)