UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gzK+pdHEcay1lui5cSu4L3VUMOwFt+sW07cllNSoQuo=' 
WHERE 
  key_id = 'bdd40e5b86d80fe90064a326e7700f6643277dd5a2c930ef734ee6b0b1184bb9' 
  AND (
    token = 'gzK+pdHEcay1lui5cSu4L3VUMOwFt+sW07cllNSoQuo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033