UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KvO1EV5vfFIAWHzjQy8zXOUzrOkmIwBLvezxqbhpVj4='
WHERE
key_id = 'ef47c667fa11b7ca17083f9636e8e34724f0dc33d6653be0c471e8c5353e66f8'
AND (
token = 'KvO1EV5vfFIAWHzjQy8zXOUzrOkmIwBLvezxqbhpVj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)