UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MJlNPMOLZT6IZ6LA/PRICCpywhE/VFq+WSrD9fjC7+o=' 
WHERE 
  key_id = '259941d05de2f4c4ff5fdff0422dbd8a6167ec0a2f055e51d5fc531c584ee9e0' 
  AND (
    token = 'MJlNPMOLZT6IZ6LA/PRICCpywhE/VFq+WSrD9fjC7+o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037