UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k7BN35vGezWdR0CVZcrAyF6laeXGBqIebh3BSDDkUHw='
WHERE
key_id = '22c701ba787d2b7cfa8cc7d64aa7c80df498ed744ce09b6d70e47bb31a2ffbad'
AND (
token = 'k7BN35vGezWdR0CVZcrAyF6laeXGBqIebh3BSDDkUHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)