UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hiv40qJ+8wRxTGDHbLtbs+9jrkErPgWFmS3+4mzui1Q=' 
WHERE 
  key_id = '6363ac8433977eb1189f3acad17a8183c488e02a98fce33b0a024aabd07df43b' 
  AND (
    token = 'hiv40qJ+8wRxTGDHbLtbs+9jrkErPgWFmS3+4mzui1Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029