UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tq3mdwWpBL77b+EMy1n8YQ55XS4NrFftLBG8dkbs5k='
WHERE
key_id = '3c473f91cbbecbdebf575b2fbfd50fcc2bcec8bacd6999bd0111687b04e3421a'
AND (
token = '8tq3mdwWpBL77b+EMy1n8YQ55XS4NrFftLBG8dkbs5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)