UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfwMtrGTWPH1OylxNafKe3PzJQMvG0b9JhF8gEzO8w8='
WHERE
key_id = '3e70c69fb37258268aec10127f8782db41afda452d8aa50385095e4c6c77f508'
AND (
token = 'zfwMtrGTWPH1OylxNafKe3PzJQMvG0b9JhF8gEzO8w8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)