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