UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FJ64BLNK2xqqaVs2yZiNADjQs2Dim1hwZd2R2zhSL+I=' 
WHERE 
  key_id = 'cdbfd9e4a918852b64473acd5faeeb9229cf5ef2f1a002b6b0abed83ba61785a' 
  AND (
    token = 'FJ64BLNK2xqqaVs2yZiNADjQs2Dim1hwZd2R2zhSL+I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034