UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'I1a7mzE3V4i2A+hyIVn9DB0HZ3uSIuSAy9NZvp3IPRw=' 
WHERE 
  key_id = '360774d202b2d7f168b73e18e9b622c610c45ebc5e3e313424bd5e88e33d1a94' 
  AND (
    token = 'I1a7mzE3V4i2A+hyIVn9DB0HZ3uSIuSAy9NZvp3IPRw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040