SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '89c3c6f12db952c4654ce3ac1047a8569a252361eed467a0b9bbe0c2739e94c0' 
  AND token = '2HWGXhyULVIjw1XtRbnusJz7t/kVi7IoAdG7pwlkSW8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}