UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6WNqk7Id3KeRq1Xay5NDu7U4jqlz7AgqTzN3cwttWPc=' 
WHERE 
  key_id = '09eab34efad38e8977a80b362aac0464b19143182bc0101321b8e88b8c07e0cd' 
  AND (
    token = '6WNqk7Id3KeRq1Xay5NDu7U4jqlz7AgqTzN3cwttWPc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042