UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5AqV/5UYJg/FVk57SYCRfmxvjyB3q4N6d4b/w3yd0Ec=' 
WHERE 
  key_id = '92ec9ab5bccca89b0fa62d49cff19d3c5787b44de0d42825bfca7de16c1a2b52' 
  AND (
    token = '5AqV/5UYJg/FVk57SYCRfmxvjyB3q4N6d4b/w3yd0Ec=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034