UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TOL3e3S1HGNP9muYVG0dftkHnSTRp8/iXkym6kgbYKE='
WHERE
key_id = 'd63a47419687356d16fa0b79d19cea7bcf226175b4c33d159d5627163651028a'
AND (
token = 'TOL3e3S1HGNP9muYVG0dftkHnSTRp8/iXkym6kgbYKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)